|
|
| Author |
Thread Statistics | Show CCP posts - 12 post(s) |
Narusegawa Naru
   |
Posted - 2006.02.10 10:30:00 -
[1]
Unfortunately these SQL exports are designed around MS-SQL (T-SQL) which is a shame. However I've imported mine to MySQL 4.11 by running a search and replace on "dbo." (the table owner shouldn't be prefixed anyway), and also on ".csv" as table names shouldn't contain special characters. And lastly there are 2 CREATE TABLE statements that have a value on UNKNOWN
CREATE TABLE dbo.dgmAttributeTypes(
attributeID UNKNOWN,
Change these to INTEGER and things work fine. Albeit MySQL can be VERY slow when using joins in your SQL so it's best to remember to create INDEX's on the ID columns using normal indexing logic, which if your even bothering to use these exports you should atleast know basic database administration and optimization.
|
Narusegawa Naru
|
Posted - 2006.02.24 11:39:00 -
[2]
Iavia: Using MyISAM type aswell here. utf8_general_ci collation aswell, I use this throughout my server. I really should upgrade from 4.1.11 to 5 at some point but I need to make sure all my other applications (including mail servers) use the new headers aswell. It's a big step upgrading a live mail server database while maintaining the 100% uptime.
|
Narusegawa Naru
|
Posted - 2006.07.06 11:59:00 -
[3]
Iteron productID = 650
My SQL query (this is from mySQL but is pretty generic SQL anyway). chrMinerals is a table containing my minerals, using the same typeID as minerals.
 Quote:
SELECT (
SELECT typeName
FROM invTypes
WHERE typeID = T.requiredTypeID
) "typeName", ROUND( T.quantity * 1.10 ) "required", C.typeQuantity "gathered"
FROM TL2MaterialsForTypeWithActivity T
LEFT OUTER JOIN chrMinerals C ON ( T.requiredTypeID = C.typeID )
AND (
C.charID = '243976002'
)
JOIN invTypes iT ON iT.typeID = T.requiredTypeID
WHERE T.typeID = '650'
AND T.activity = 6
ORDER BY iT.typeID;
If I use activity = 1 I get nothing.
Activity 6
Quote:
Tritanium
Pyerite
Mexallon
Isogen
Nocxium
Zydrine
Megacyte
Industrial Construction
Terran Molecular Sequencer
R.A.M.- Cruiser Tech
Activity 7
Quote:
Tritanium
Pyerite
Mexallon
Isogen
Nocxium
Zydrine
Megacyte
Criminal Connections
Hacker Deck - Hermes
Hyper Net Uplink
Why would 2 skill books be in there as constuction components? I'm just trying to get a list of manufacturing components of whats required to build a product.
|
Narusegawa Naru
Gallente
The Underground
|
Posted - 2006.08.21 14:28:00 -
[4]
Has anyone got a MSSQL 2000 export of this? I've tried to import it but get a ton of errors.
Loads of ,) in there, and ,,. Not to mention DOUBLE which isnt support, and PRECISION.
I've got this imported into MySQL but would like to get it into MSSQL as well.
|
|
|
| |
|